package com.gimi.cloud.jimi.dao.dao.prod;

import com.gimi.cloud.jimi.dao.myMapper.MyMapper;
import com.gimi.cloud.jimi.entity.prod.CategoryBrandRelaEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * Created by lixj on 2017/12/21.
 */
@Mapper
public interface CategoryBrandRelaDao extends MyMapper<CategoryBrandRelaEntity> {

    /**
     * 获取商品品类列表
     * @return
     */
    @Select("SELECT * FROM ec_category_brand_rela WHERE prod_brand_id=#{pdId}")
    CategoryBrandRelaEntity findByBrandId(Long pdId);

    /**
     * 获取商品品类列表
     * @return
     */
    @Select("SELECT * FROM ec_category_brand_rela WHERE prod_cat_id=#{prodCatId}")
    CategoryBrandRelaEntity findByProdCatId(String prodCatId);
}
